Step 3: Summary options

Note: This wizard step is only available if you've applied data grouping in the previous step (see Step 2: Add grouping levels).

Purpose

Use this dialog to specify totals to be displayed for each data group, or grand totals for the entire report. For instance, you may need to display the sum of values in a particular field, the average value, etc. Specified totals will be displayed after corresponding groups, and in the report footer.

Dialog

This dialog displays all of the available numerical and date-time fields that aren't used to group data. Using the check box table, you can specify which functions should be calculated for these fields.

Sometimes, data fields can contain empty values (this is different from zero in a numeric field). If you don't want to take these values into account when calculating totals, check Ignore null values. Otherwise, these values will be treated as zeros for numeric fields and as the earliest system date for date-time fields.

Result

You can stop the wizard at this step by clicking Finish. In this case, your report will look similar to the image below.

If you want to customize your report further, click Next to proceed.